﻿DROP TABLE IF EXISTS `open_affix`;
CREATE TABLE `open_affix` (
  `affix_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ctype` varchar(200) NOT NULL DEFAULT '',
  `cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `affix_name` varchar(255) NOT NULL DEFAULT '',
  `virtual_path` varchar(255) NOT NULL DEFAULT '',
  `width` smallint(5) NOT NULL DEFAULT '0',
  `height` smallint(5) NOT NULL DEFAULT '0',
  `size` int(11) NOT NULL DEFAULT '0',
  `up_time` int(10) unsigned NOT NULL DEFAULT '0',
  `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`affix_id`),
  KEY `ctype` (`ctype`),
  KEY `cid` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;